package springboot.dao;

import org.apache.ibatis.annotations.Mapper;
import springboot.doMain.Msg;
import springboot.doMain.OverTimeData;
import springboot.doMain.TbProblemStatus;

import java.util.List;
import java.util.Map;

@Mapper
public interface TbProblemStatusDao {

    TbProblemStatus lastStatus(int idProblemStatus);

    int insertProblemStatusContent(TbProblemStatus tbProblemStatus);

    List<TbProblemStatus> selAll();

    List<TbProblemStatus> problemStatusByHq(int hq);

    int addProblemStatus(Msg msg);
    
    int inserNewProblemStatus();

    int selProblemCount(int hq);

    List<Map<String, Object>> selEngineerNeedAddProblemStatusCount();

    List<Msg> problemNoStatus();

    List<Map<String, Object>> selEngineerNeedToReplyNum(Long time);

    List<OverTimeData> selOverTimeData();

    List<Map<String, Object>> selOverTimePro();

    List<Map<String, Object>> selOverTimeMsg();


    int del_pro_status(int idProblemStatus);
}